Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | StockItem(AS_ITM_STK) |
ValidationFlag | An indicator used to identify if the SERIALIZED ITEM requires operator validation after payment has been made and prior to customer pickup. | FL_VLD_SRZ_ITM | Flag | integer | |
StoreWarrantyDescriptionCode | A code to signify the type of warranty offered by the RETAIL STORE. This warranty normally supplements the warranty offered by the MANUFACTURER | LU_WRTY_STR_SRZ | Code4 | char(4) | |
ManufacturerWarrantyDescriptionCode | A code to denote the type of warranty offered on the SERIALIZED ITEM by the MANUFACTURER | LU_WRTY_MF_SRZ_ITM | Code4 | char(4) | |
ManufacturerSizeDescription | A code to signify the maufacturer's size reference. | DE_SZ_MF_SRZ_ITM | DescriptionShort | varchar(255) | |
ModelYear | The year of release or production of the SERIALIZED ITEM | CY_MDL_SRZ_ITM | DateCalendarYear | char(4) | |
ModelNumber | The model reference for a specific SERIALIZED ITEM. | NM_NMB_SRZ_ITM | Name | varchar(40) | |
ManufacturerColorDescription | The code to signify the manufacturer's color shade. | DE_CLR_MF_SRZ_ITM | DescriptionShort | varchar(255) | |